"192.168.0.1:sipop"

PATOLOGIAS_AI

Descriptions

There is no desription for trigger PATOLOGIAS_AI

Definition

CREATE TRIGGER PATOLOGIAS_AI FOR PATOLOGIAS ACTIVE
AFTER INSERT POSITION 0
AS
declare variable PADRE CHAR(13);
declare variable HIJO integer;
BEGIN
  /* Trigger body */

   SELECT COUNT (ID_PATOLOGIAS) FROM PATOLOGIAS
   WHERE
           ID_PADRE_PATOLOGIA = NEW.ID_PADRE_PATOLOGIA
   INTO:HIJO;
  UPDATE PATOLOGIAS SET HIJOS = :HIJO WHERE ID_PATOLOGIAS = new.ID_PADRE_PATOLOGIA;


END

This file was generated with EMS InterBase/FireBird Manager (www.ibmanager.com) at 09/06/2005 05:52 p.m.